from sqlalchemy import Column, Integer, String, Date
from .stu_database import Base


class Stu(Base):
    __tablename__ = 'student_basic_information'

    student_id = Column(Integer, primary_key=True, comment="学生编号")
    class_name = Column(String(20), nullable=False, comment="学生班级")
    student_name = Column(String(20), nullable=False, comment="学生姓名")
    hometown = Column(String(20), nullable=True, comment="籍贯")
    previous_school = Column(String(20), nullable=False, comment="毕业学校")
    major = Column(String(20), nullable=False, comment="专业")
    enrollment_date = Column(Date, nullable=True, comment="入学时间")
    graduation_date = Column(Date, nullable=True, comment="毕业时间")
    education_level = Column(String(10),nullable=False,comment='学历')
    advisor_id = Column(Integer,nullable=False,comment='顾问编号')
    age = Column(Integer,nullable=False,comment='年龄')
    gender = Column(String(10),nullable=False,comment='性别')


